USE [GradingSystemDb]

SET IDENTITY_INSERT [dbo].[ExaminationTypes] ON

INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (1,'Attendance','((Attendace/4)*50)+50',1,1,GETDATE(),1,GETDATE());
INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (2,'Assignments','(Assignments + Recitation + Projects)/3',2,1,GETDATE(),1,GETDATE());
INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (3,'Recitation','(Assignments + Recitation + Projects)/3',2,1,GETDATE(),1,GETDATE());
INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (4,'Projects','(Assignments + Recitation + Projects)/3',2,1,GETDATE(),1,GETDATE());
INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (5,'Quiz # 1','(((Quiz#1 + Quiz#2 + Quiz#3)/300)*60)+40',3,1,GETDATE(),1,GETDATE());
INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (6,'Quiz # 2','(((Quiz#1 + Quiz#2 + Quiz#3)/300)*60)+40',3,1,GETDATE(),1,GETDATE());
INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (7,'Quiz # 3','(((Quiz#1 + Quiz#2 + Quiz#3)/300)*60)+40',3,1,GETDATE(),1,GETDATE());
INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (8,'Major Exam','((Major Exam/100)*60)+40',4,1,GETDATE(),1,GETDATE());
INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (9,'Preliminary','',0,1,GETDATE(),1,GETDATE());
INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (10,'MidTerm','',0,1,GETDATE(),1,GETDATE());
INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (11,'Pre-Finals','',0,1,GETDATE(),1,GETDATE());
INSERT [dbo].[ExaminationTypes] ([ExaminationTypeId],[Name],[Description],[GroupId],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (12,'Finals','',0,1,GETDATE(),1,GETDATE());

SET IDENTITY_INSERT [dbo].[ExaminationTypes] OFF

USE [GradingSystemDb]

SET IDENTITY_INSERT [dbo].[Courses] ON

INSERT [dbo].[Courses] ([CourseId],[Name],[Code],[Description],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (1,'Not Applicable','NA','Not Applicable',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Courses] ([CourseId],[Name],[Code],[Description],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (2,'B.S. Information Technology','BSIT','Bachelor of Science in Information Technology',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Courses] ([CourseId],[Name],[Code],[Description],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (3,'B.S. Computer Science','BSCS','Bachelor of Science in Computer Science',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Courses] ([CourseId],[Name],[Code],[Description],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (4,'B.S. Information Management','BSIM','Bachelor of Science in Information Management',1,GETDATE(),1,GETDATE());
INSERT [dbo].[Courses] ([CourseId],[Name],[Code],[Description],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (5,'B.S. Hotel & Restaurant Management','BSHRM','Bachelor of Science in Hotel & Restaurant Management',1,GETDATE(),1,GETDATE());

SET IDENTITY_INSERT [dbo].[Courses] OFF

USE [GradingSystemDb]

SET IDENTITY_INSERT [dbo].[EmployeeTypes] ON

INSERT [dbo].[EmployeeTypes] ([EmployeeTypeId],[Name],[Description],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (1,'Administrator','System Administrator',1,GETDATE(),1,GETDATE());
INSERT [dbo].[EmployeeTypes] ([EmployeeTypeId],[Name],[Description],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (2,'Registrar','Regular Registrar',1,GETDATE(),1,GETDATE());
INSERT [dbo].[EmployeeTypes] ([EmployeeTypeId],[Name],[Description],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (3,'Instructor','Regular Instructor',1,GETDATE(),1,GETDATE());
INSERT [dbo].[EmployeeTypes] ([EmployeeTypeId],[Name],[Description],[CreatedBy],[CreatedDttm],[ModifiedBy],[ModifiedDttm]) VALUES (4,'Student','Regular Student',1,GETDATE(),1,GETDATE());

SET IDENTITY_INSERT [dbo].[EmployeeTypes] OFF



